# 导入蓝图模块
from flask import Blueprint,request,json,jsonify
# 实例化

from db import db1
bp_course = Blueprint("course",__name__)

# 接口
# @bp_course.route('/course',methods=['POST','GET','PUT','DELETE'])
# def course():
#     # 添加
#     if  request.method=='POST':
#         # 获取用户输入
#         data=request.data
#         if data:
#             data=json.loads(data)
#         else:
#             data=request.form
#         # 构造sql语句
#         sql="insert into coupon values(0,'%s',%d,'%s','%s')"%(data['name'],int(data['total']),data['start'],data['end'])
#         db1.insert(sql)
#         return 'ok'
#     elif request.method =='GET':
#         #根据id获取信息
#         id = request.args.get('id')
#         sql = "select * from test where id=%d"(int(id))
#         res = db1.find(sql)
#         return jsonify({"code":200,'test':res})
#     elif request.method == 'PUT':
#         # 修改
#         # 获取用户输入
#         data = request.data
#         if data:
#             data = json.loads(data)
#         else:
#             data = request.form
#         print(data)
#         # 构造sql语句 update 表名coupon set 字段名1=值 字段名2=值 where id=1
#         sql = "update coupon set name='%s',total=%d,starttime='%s',endtime='%s' where id=%d"%(data['name'],int(data['total']),data['stime'],data['etime'],int(data['id']))
#         print(sql)
#         db1.insert(sql)
#         return jsonify({"code":200})

#     elif request.method == "DELETE":
#         id = request.args.get('id')
#         sql = "delete from coupon where id=%d"%(int(id))
#         db1.insert(sql)
#         return jsonify({"code":200})

import os
from myfile import myfile
# 文件上传
@bp_course.route('/upload',methods=['POST'])
def upload():
    # 获取文件
    file = request.files['file']
    # 选择文件夹
    # 创建文件
    myfile.file_mkdir(2)
    # 保存文件
    file.save(os.path.join('./static/upload/2/',file.filename))
    # 保存
    return 'ok'